/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50513
 Source Host           : localhost
 Source Database       : ng

 Target Server Version : 50513
 File Encoding         : utf-8

 Date: 07/13/2011 21:59:01 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `real_estate_transfer`
-- ----------------------------
DROP TABLE IF EXISTS `real_estate_transfer`;
CREATE TABLE `real_estate_transfer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `street_id` int(11) NOT NULL,
  `street_number` varchar(20) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `type` smallint(6) NOT NULL,
  `bedroom` smallint(6) NOT NULL,
  `ensuite` smallint(6) NOT NULL,
  `bathroom` smallint(6) NOT NULL,
  `car_space` smallint(6) NOT NULL,
  `land_area` int(11) NOT NULL,
  `floor_area` int(11) NOT NULL,
  `primary_use` smallint(6) NOT NULL,
  `contract_date` date NOT NULL,
  `possession_date` date NOT NULL,
  `transfer_price` decimal(9,2) NOT NULL,
  `transfer_type` smallint(6) NOT NULL,
  `is_agents_advice` tinyint(1) NOT NULL,
  `agent_name` varchar(255) NOT NULL,
  `agency_name` varchar(255) NOT NULL,
  `sale_type` smallint(6) NOT NULL,
  `capital_value_at_sale` decimal(9,2) NOT NULL,
  `ucv_at_sale` decimal(9,2) NOT NULL,
  `valuation_date_at_sale` date NOT NULL,
  `improvements_value` decimal(9,2) NOT NULL,
  `document_number` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `real_estate_transfer_539ecf1b` (`street_id`),
  CONSTRAINT `street_id_refs_id_dfffcc0e` FOREIGN KEY (`street_id`) REFERENCES `location_street` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `real_estate_transfer`
-- ----------------------------
BEGIN;
INSERT INTO `real_estate_transfer` VALUES
('1', '1', '1', '1', '0', '4', '2', '2', '2', '430', '300', '0', '2010-12-10', '2011-01-10', '530000.00', '1', '0', 'anne', 'LJ Hooker', '1', '330000.00', '530000.00', '2010-12-10', '200000.00', 'Doc_1234567'),
('2', '1', '7/8', '2', '1', '3', '1', '2', '1', '180', '180', '0', '2010-09-02', '2010-10-02', '390000.00', '2', '0', 'jack', 'Ray White', '2', '190000.00', '390000.00', '2010-09-02', '200000.00', 'Doc_1234567'),
('3', '1', '10/8', '3', '1', '3', '1', '2', '1', '150', '180', '0', '2010-08-15', '2010-09-15', '378000.00', '2', '0', 'jack', 'Ray White', '2', '178000.00', '378000.00', '2010-08-15', '200000.00', 'Doc_1234567'),
('4', '1', '12/8', '4', '1', '3', '1', '2', '1', '165', '180', '0', '2010-07-09', '2010-08-09', '385000.00', '2', '0', 'anne', 'LJ Hooker', '2', '185000.00', '385000.00', '2010-07-09', '200000.00', 'Doc_1234567'),
('5', '1', '10', '5', '0', '4', '2', '4', '2', '530', '350', '0', '2010-11-11', '2010-12-11', '640000.00', '1', '0', 'sam', 'Yong', '1', '440000.00', '640000.00', '2010-11-11', '200000.00', 'Doc_1234567'),
('6', '1', '6', '6', '0', '5', '3', '4', '3', '680', '400', '0', '2010-10-10', '2010-11-10', '670000.00', '1', '0', 'sam', 'Yong', '1', '470000.00', '670000.00', '2010-10-10', '200000.00', 'Doc_1234567'),
('7', '1', '4', '7', '0', '4', '2', '3', '2', '600', '320', '0', '2010-06-05', '2010-07-05', '780000.00', '1', '0', 'sam', 'Yong', '1', '580000.00', '780000.00', '2010-06-05', '200000.00', 'Doc_1234567'),
('8', '2', '104', '8', '2', '0', '0', '2', '5', '200', '200', '1', '2010-05-04', '2010-06-04', '550000.00', '1', '0', 'sam', 'Yong', '1', '350000.00', '550000.00', '2010-05-04', '200000.00', 'Doc_1234567'),
('9', '2', '150', '9', '2', '0', '0', '2', '6', '300', '300', '1', '2010-04-21', '2010-05-21', '630000.00', '1', '0', 'anne', 'LJ Hooker', '1', '430000.00', '630000.00', '2010-04-21', '200000.00', 'Doc_1234567'),
('10', '2', '400', '10', '2', '0', '0', '2', '5', '270', '370', '1', '2010-03-30', '2010-04-30', '890000.00', '1', '0', 'anne', 'LJ Hooker', '1', '690000.00', '890000.00', '2010-03-30', '200000.00', 'Doc_1234567'),
('11', '2', '250', '11', '3', '0', '0', '2', '6', '400', '400', '1', '2010-02-27', '2010-03-27', '1002000.00', '2', '0', 'jack', 'Ray White', '2', '802000.00', '1002000.00', '2010-02-27', '200000.00', 'Doc_1234567'),
('12', '2', '280', '12', '3', '0', '0', '2', '8', '500', '500', '1', '2010-01-18', '2010-02-18', '1300000.00', '2', '0', 'jack', 'Ray White', '2', '1000000.00', '1300000.00', '2010-01-18', '300000.00', 'Doc_1234567'),
('13', '2', '283', '13', '3', '0', '0', '2', '6', '500', '500', '1', '2009-12-02', '2010-01-02', '580000.00', '1', '0', 'jack', 'Ray White', '1', '280000.00', '580000.00', '2009-12-02', '300000.00', 'Doc_1234567'),
('14', '2', '264', '14', '3', '0', '0', '2', '4', '300', '300', '1', '2009-11-03', '2009-12-03', '780000.00', '1', '0', 'jack', 'Ray White', '1', '580000.00', '780000.00', '2009-11-03', '200000.00', 'Doc_1234567'),
('15', '3', '97', '15', '0', '4', '2', '3', '2', '540', '420', '0', '2009-10-08', '2009-11-08', '480000.00', '1', '0', 'paul', 'LJ Hooker', '1', '280000.00', '480000.00', '2009-10-08', '200000.00', 'Doc_1234567'),
('16', '3', '96', '16', '0', '4', '2', '3', '2', '700', '480', '0', '2009-09-17', '2009-10-17', '590000.00', '1', '0', 'paul', 'LJ Hooker', '1', '390000.00', '590000.00', '2009-09-17', '200000.00', 'Doc_1234567'),
('17', '3', '94', '17', '0', '5', '3', '4', '2', '800', '460', '0', '2009-08-16', '2009-09-16', '630000.00', '1', '0', 'paul', 'LJ Hooker', '1', '430000.00', '630000.00', '2009-08-16', '200000.00', 'Doc_1234567'),
('18', '3', '93', '18', '0', '5', '3', '3', '3', '890', '520', '0', '2009-07-09', '2009-08-09', '510000.00', '2', '0', 'paul', 'LJ Hooker', '2', '310000.00', '510000.00', '2009-07-09', '200000.00', 'Doc_1234567'),
('19', '3', '88', '19', '0', '6', '4', '4', '3', '1200', '600', '0', '2009-06-23', '2009-07-23', '900000.00', '2', '0', 'jack', 'Ray White', '2', '700000.00', '900000.00', '2009-06-23', '200000.00', 'Doc_1234567'),
('20', '3', '83', '20', '5', '0', '0', '0', '0', '1500', '0', '4', '2009-05-12', '2009-06-12', '710000.00', '2', '0', 'sam', 'Yong', '2', '510000.00', '710000.00', '2009-05-12', '200000.00', 'Doc_1234567'),
('21', '3', '85', '21', '7', '0', '0', '0', '0', '1009', '0', '4', '2009-04-11', '2009-05-11', '880000.00', '1', '0', 'anne', 'LJ Hooker', '1', '680000.00', '880000.00', '2009-04-11', '200000.00', 'Doc_1234567');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
